create external table if not exists ai_group.ai_route_city_effective (
  `in_from_city_code` string COMMENT '始发市编码',
  `in_from_city_desc` string COMMENT '始发市',
  `out_to_city_code`  string COMMENT '目的市',
  `out_to_city_desc`  string COMMENT '目的市',
  `total_days_use`    string COMMENT '全程时效(X日达)',
  `total_time_use`    int COMMENT '全程耗时(小时)',
  `total_days_t`      string COMMENT '全程T+时效(天)'
)comment '城市时效最快表'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/ai_group.db/external/ai_route_city_effective'
tblproperties (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);

